Simmons Alumni on the Map

Data Source

• Dataset from the Simmons Alumnae/i Office
  • Data queries are available by request!
  • Information provided without names of alumni
• Jasmine Clark ‘15
  • Assistant Director, Career Development and Education
  • Met to discuss the project with her

Demographic Variables

• ID
  • Unique identifier of each alumni
• Deceased?
  • Changed to “Dead”
  • Made 0/1 from “yes”/“no”

    • • 	Dead?	Perc
        Alive	0	96.64
        Dead	1	3.36

• Age
  • • • 

        	min	Q1	median	Q3	max	mean	sd	n	missing
        	1	14	28	36	80	25.51391	14.32987	22072	0

• Gender

  • • • Gender	%
        Female	99.94
        Male	0.04
        Unknown	0.02

• Race/Ethnicity
  • Changed to “Race”

    • • 	Race	Perc
        1		46.16
        9	White	42.78
        4	Black or African American	5.10
        3	Asian	3.73
        5	Latino/a or Hispanic	1.55
        6	Multi-Racial	0.40
        2	American Indian or Alaskan Native	0.15
        8	Unknown/International	0.10
        7	Native Hawaiian/Pacific Islander	0.02

The Data: Education Variables

• Class
  • What year they graduated
    • • 

        	Class Year	Count
        52	2011	560
        28	1987	494
        50	2009	488
        51	2010	484
        57	2016	479
        55	2014	478

• Major 1
• Major 2
  • • • 

        	Major 1	Perc
        85	Nursing	15.84
        26	Communications	8.00
        37	Education	5.57
        98	Psychology	5.48
        73	Management	4.69
        43	English	4.39

• Minor 1
• Minor 2
  • • • 

        	Minor 1	Perc
        57	Psychology	0.99
        9	Biology	0.72
        20	Economics	0.57
        14	Chemistry	0.45
        25	English	0.35
        55	Political Science	0.28

The Data: Career Variables

• Position
  • Their job title/role
• Profession
  • Generalized role like “nurse”, mostly missing
    • • 

        	Profession	Perc
        42	Nurse	0.70
        4	Attorney	0.18
        63	Social Worker	0.16
        48	Physical Therapist	0.12
        57	Real Estate Broker	0.08
        34	Librarian	0.06

• Industry
  • Categorical
    • • 

        	Industry	Perc
        45	Healthcare/Medical Services	6.54
        27	Education - Higher	1.60
        29	Education - Primary/Secondary	0.99
        2	Advertising/Public Relations/Marketing	0.89
        44	Health/Fitness	0.58
        60	Pharmaceutical/Biotechnology	0.45

The Data: Location Variables

• City
  • At least 3,751 different cities!
• State
• These were merged in R to one column named “loc”
  • “{City}, {State}”
    • • 

        	State	Perc
        27	MA	48.44
        45	NY	5.53
        11	CA	5.04
        13	CT	4.81
        40	NH	3.87
        16	FL	3.80

The Data: Missing Values

	Variable	missing	Perc
7	Minor 2	21782	98.69
9	Profession	21621	97.96
6	Minor 1	20235	91.68
5	Major 2	18973	85.96
10	Industry	17948	81.32
8	Position	11701	53.01
3	Race	10189	46.16
1	Age	1874	8.49
4	Major 1	159	0.72
11	Loc	138	0.63
2	Gender	0	0.00

Analysis: Nursing

• Leaflet Map
  • 856 nurses live in New England, of the 1073 identified and located!(~80%)

	State	Freq
27	MA	695
40	NH	59
11	CA	44
13	CT	39
29	ME	30
45	NY	24

-Chloropleth Map

-Bureau of Labor Statistics Comparisons

Thank you!

• Future Work
  • Look at more Majors
  • Look at specific states
  • Examine landmarks (ie. Hospitals)
  • Use natural language processing
• Play around with the map!
  • https://drive.google.com/open?id=12xt3gL0mghM6vz5LfRU0Y8JjWlKbTUMn&usp=sharing